Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
SID NUMBER(38) No null 1 null NO NO NO
OBJ VARCHAR2(20) No null 2 null NO NO NO
NONINDIV_NAME NUMBER(38) Yes null 3 null NO NO NO
NONINDIV_TYPE VARCHAR2(100) Yes null 4 null NO NO NO
NONINDIV_SUBTYPE VARCHAR2(100) Yes null 5 null NO NO NO
TIMES_SUBJECT NUMBER Yes null 6 null NO NO NO
INVOLVEMENT_COUNT NUMBER Yes null 7 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 12-APR-23
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_CUBE_PARTIC_NONINDIV
TEXT_LENGTH 1413
TEXT SELECT DISTINCT I.SID,                    I.OBJ,                    N.SID AS NONINDIV_NAME,                    NT.DISPLAY AS NONINDIV_TYPE,                    NST.DISPLAY AS NONINDIV_SUBTYPE,                    NVL(T.SUBJECT_COUNT, 0) AS TIMES_SUBJECT,                    NVL(INV.INVOLVEMENT_COUNT, 0) AS INVOLVEMENT_COUNT      FROM MV_PARTIC_NONINDIV I      LEFT JOIN MV_PARTIC_NAME N ON I.OBJ = N.OBJ       AND N.IS_CURRENT = 'Y'      LEFT JOIN MV_PARTIC_NONINDIV_TYPE NT ON NT.SID = I.NONINDIV_TYPE      LEFT JOIN MV_PARTIC_NONINDIV_SUBTYPE NST ON NST.SID = I.NONINDIV_SUBTYPE      LEFT JOIN ( SELECT PARTICIPANT,                         COUNT(1) SUBJECT_COUNT                                          FROM MV_PARTIC_INVOLVEMENT MPI                             WHERE INVOLVEMENT_ROLE IN ( SELECT SID                                                                                      FROM MV_PARTIC_ROLE_TYPE                                                         WHERE CODE = 'SUBJECT'                                                       )                 GROUP BY PARTICIPANT                ) T ON I.OBJ = T.PARTICIPANT      LEFT JOIN ( SELECT PARTICIPANT,                         COUNT(1) INVOLVEMENT_COUNT                                          FROM MV_PARTIC_INVOLVEMENT MPI                             WHERE 1 = 1                 GROUP BY PARTICIPANT                ) INV ON I.OBJ = INV.PARTICIPANT
TEXT_VC SELECT DISTINCT I.SID,                    I.OBJ,                    N.SID AS NONINDIV_NAME,                    NT.DISPLAY AS NONINDIV_TYPE,                    NST.DISPLAY AS NONINDIV_SUBTYPE,                    NVL(T.SUBJECT_COUNT, 0) AS TIMES_SUBJECT,                    NVL(INV.INVOLVEMENT_COUNT, 0) AS INVOLVEMENT_COUNT      FROM MV_PARTIC_NONINDIV I      LEFT JOIN MV_PARTIC_NAME N ON I.OBJ = N.OBJ       AND N.IS_CURRENT = 'Y'      LEFT JOIN MV_PARTIC_NONINDIV_TYPE NT ON NT.SID = I.NONINDIV_TYPE      LEFT JOIN MV_PARTIC_NONINDIV_SUBTYPE NST ON NST.SID = I.NONINDIV_SUBTYPE      LEFT JOIN ( SELECT PARTICIPANT,                         COUNT(1) SUBJECT_COUNT                                          FROM MV_PARTIC_INVOLVEMENT MPI                             WHERE INVOLVEMENT_ROLE IN ( SELECT SID                                                                                      FROM MV_PARTIC_ROLE_TYPE                                                         WHERE CODE = 'SUBJECT'                                                       )                 GROUP BY PARTICIPANT                ) T ON I.OBJ = T.PARTICIPANT      LEFT JOIN ( SELECT PARTICIPANT,                         COUNT(1) INVOLVEMENT_COUNT                                          FROM MV_PARTIC_INVOLVEMENT MPI                             WHERE 1 = 1                 GROUP BY PARTICIPANT                ) INV ON I.OBJ = INV.PARTICIPANT
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT